Excel 2019 - Expert - Auditing, The Watch Window and External Data
      This course is part of the MOS exam 77-728 range that will teach you the essential skills to successfully pass the Microsoft Office Specialist (MOS) Expert certification exam.      
      Auditing Tools      
      Upon successful completion you will be able to:

1. Trace Precedents;
2. Trace Dependents;
3. Remove Tracer Arrows;
4. Trace Errors in Formulae;
5. Correct Formula Errors.
6. Display Formula Locations;
7. Show Formulas in Worksheets.
      
      Evaluating Formulas and Watch Window      
      Upon successful completion you will be able to:

1. Work with Formulas;
2. Evaluate Formulas;
3. Trace Dependents;
4. Trace Precendents;
5. Use the Watch Window.		      
      External Data and Queries      
      Upon successful completion you will be able to:

1. Get External Data;
2. Refresh External Data;
3. Import Multiple Tables;
4. Create Queries;
5. Append Queries;
6. Merge Queries;
7. Remove Fields;
8. Edit Steps;
9. Rename Fields.		      
This course can be purchased either individaully or as part of a package.
Single Training Course - Excel 2019 - Expert - Auditing, The Watch Window and External Data :
Program Training Courses - Microsoft Excel Expert 2019 :
Office Suite Training Courses - Microsoft Office 2019 / Office 365 :
© 2020 Online Training Masters